LiteDAC

TLiteConnection Members

TLiteConnection class overview.

Properties

Name Description

ClientLibrary

Used to set or get the SQLite client library location.

ClientLibraryVersion

Indicates the version of the SQLite3 client library.

ConnectDialog

Allows to link a TCustomConnectDialog component.

Connected

Used to establish a database connection.

ConnectString (inherited from TCustomDAConnection)

Used to specify the connection information, such as: UserName, Password, Server, etc.

ConvertEOL (inherited from TCustomDAConnection)

Allows customizing line breaks in string fields and parameters.

Database

Used to specify the name of the database to be used once a connection is open.

Debug

Used to display SQL statements being executed with their parameter values and data types.

EncryptionKey

Used to specify the encryption key for working with an encrypted database.

InTransaction (inherited from TCustomDAConnection)

Indicates whether the transaction is active.

LoginPrompt

Specifies whether a login dialog appears immediately before opening a new connection.

Options

Used to specify the behaviour of the TLiteConnection object.

Pooling

Enables or disables using connection pool.

PoolingOptions

Specifies the behaviour of connection pool.

Methods

Name Description

ApplyUpdates (inherited from TCustomDAConnection)

Overloaded. Applies changes in datasets.

Commit (inherited from TCustomDAConnection)

Commits current transaction.

Connect (inherited from TCustomDAConnection)

Establishes a connection to the server.

CreateDataSet

Returns a new instance of TLiteQuery class and associates it with the connection object.

CreateMetaData

Returns a new instance of TLiteMetaData class and associates it with the connection object.

CreateSQL

Returns a new instance of TLiteSQL class and associates it with the connection object.

CreateTransaction

Returns a new instance of TLiteTransaction class and associates it with the connection object.

Disconnect (inherited from TCustomDAConnection)

Performs disconnect.

EncryptDatabase

Encrypt the connected database with the encryption key specified.

GetKeyFieldNames (inherited from TCustomDAConnection)

Provides a list of available key field names.

GetTableNames (inherited from TCustomDAConnection)

Provides a list of available tables names.

MonitorMessage (inherited from TCustomDAConnection)

Sends a specified message through the TCustomDASQLMonitor component.

PerformConnect (inherited from TCustomDAConnection)

Establishes a connection to the server regardless of the LoginPrompt property.

Ping (inherited from TCustomDAConnection)

Used to check state of connection to the server.

ReleaseSavepoint

Releases the specified savepoint without affecting any work that has been performed after its creation.

RemoveFromPool (inherited from TCustomDAConnection)

Marks the connection that should not be returned to the pool after disconnect.

Rollback (inherited from TCustomDAConnection)

Discards all current data changes and ends transaction.

RollbackToSavepoint

Cancels all updates for the current transaction.

Savepoint

Defines a point in the transaction to which you can roll back later.

StartTransaction

Overloaded. Begins a new user transaction.

Events

Name Description

OnConnectionLost

This event occurs when connection was lost.

OnError

This event occurs when an error has arisen in the connection.
© 1997-2024 Devart. All Rights Reserved. Request Support DAC Forum Provide Feedback